package com.tianji.learning.service;

import com.tianji.learning.domain.po.PointsBoard;
import com.baomidou.mybatisplus.extension.service.IService;
import com.tianji.learning.domain.query.PointsBoardQuery;
import com.tianji.learning.domain.vo.PointsBoardVO;

import java.util.List;

/**
 * <p>
 * 学霸天梯榜 服务类
 * </p>
 *
 * @author fx
 * @since 2024-08-31
 */
public interface IPointsBoardService extends IService<PointsBoard> {
    /**
     * 01 分页查询积分排行榜（day08-随堂-02）
     * @param boardQuery
     * @return
     */
    PointsBoardVO queryPointsBoard(PointsBoardQuery boardQuery);

    /**
     * 02 根据赛季ID创建表（day08-随堂-03）
     * @param seasonId
     */
    void createPointsBoardTable(Integer seasonId);

    /**
     * 03 查询上月积分排行榜数据 -根据key查询（day08-随堂-04）
     * @param key
     * @param pageNo
     * @param pageSize
     * @return
     */
    List<PointsBoard> queryLastMonthPointsBoard(String key, Integer pageNo, Integer pageSize);
}
